package com.fengxing.ams.web.facade.mouble.upload;

import java.util.List;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;
import org.springframework.data.repository.query.Param;

public interface IUploadDetailDAO extends PagingAndSortingRepository<UploadDetailVO, Integer>, JpaSpecificationExecutor<UploadDetailVO>  {

	@Query(value="select * from zyt_upload_detail where upload_id=:id order by row_num", nativeQuery=true)
	List<UploadDetailVO> queryUploadDetail(@Param("id")Integer id);

}
